Pandas Profiling Report

Dataset statistics

Number of variables	19
Number of observations	30000
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	4.3 MiB
Average record size in memory	152.0 B

Variable types

Numeric	16
Categorical	3

Alerts

`PAY_0` is highly overall correlated with `PAY_2` and 2 other fields	High correlation
`PAY_2` is highly overall correlated with `PAY_0` and 8 other fields	High correlation
`PAY_3` is highly overall correlated with `PAY_0` and 9 other fields	High correlation
`PAY_4` is highly overall correlated with `PAY_0` and 10 other fields	High correlation
`PAY_5` is highly overall correlated with `PAY_2` and 8 other fields	High correlation
`PAY_6` is highly overall correlated with `PAY_2` and 8 other fields	High correlation
`overdue pay_mon1` is highly overall correlated with `PAY_2` and 7 other fields	High correlation
`overdue pay_mon2` is highly overall correlated with `PAY_2` and 9 other fields	High correlation
`overdue pay_mon3` is highly overall correlated with `PAY_2` and 9 other fields	High correlation
`overdue pay_mon4` is highly overall correlated with `PAY_2` and 9 other fields	High correlation
`overdue pay_mon5` is highly overall correlated with `PAY_3` and 8 other fields	High correlation
`overdue pay_mon6` is highly overall correlated with `PAY_4` and 7 other fields	High correlation
`ID` is uniformly distributed	Uniform
`ID` has unique values	Unique
`PAY_0` has 14737 (49.1%) zeros	Zeros
`PAY_2` has 15730 (52.4%) zeros	Zeros
`PAY_3` has 15764 (52.5%) zeros	Zeros
`PAY_4` has 16455 (54.9%) zeros	Zeros
`PAY_5` has 16947 (56.5%) zeros	Zeros
`PAY_6` has 16286 (54.3%) zeros	Zeros
`overdue pay_mon1` has 2139 (7.1%) zeros	Zeros
`overdue pay_mon2` has 2503 (8.3%) zeros	Zeros
`overdue pay_mon3` has 2890 (9.6%) zeros	Zeros
`overdue pay_mon4` has 3118 (10.4%) zeros	Zeros
`overdue pay_mon5` has 3364 (11.2%) zeros	Zeros
`overdue pay_mon6` has 3854 (12.8%) zeros	Zeros

Reproduction

Analysis started	2024-06-30 11:43:13.939012
Analysis finished	2024-06-30 11:44:34.746840
Duration	1 minute and 20.81 seconds
Software version	ydata-profiling v4.8.3
Download configuration	config.json

ID
Real number (ℝ)

UNIFORM UNIQUE

Distinct	30000
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15000.5

Minimum	1
Maximum	30000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	234.5 KiB

Quantile statistics

Minimum	1
5-th percentile	1500.95
Q1	7500.75
median	15000.5
Q3	22500.25
95-th percentile	28500.05
Maximum	30000
Range	29999
Interquartile range (IQR)	14999.5

Descriptive statistics

Standard deviation	8660.3984
Coefficient of variation (CV)	0.57734065
Kurtosis	-1.2
Mean	15000.5
Median Absolute Deviation (MAD)	7500
Skewness	0
Sum	4.50015 × 10⁸
Variance	75002500
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1	< 0.1%
19997	1	< 0.1%
20009	1	< 0.1%
20008	1	< 0.1%
20007	1	< 0.1%
20006	1	< 0.1%
20005	1	< 0.1%
20004	1	< 0.1%
20003	1	< 0.1%
20002	1	< 0.1%
Other values (29990)	29990	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%
10	1	< 0.1%

Value	Count	Frequency (%)
30000	1	< 0.1%
29999	1	< 0.1%
29998	1	< 0.1%
29997	1	< 0.1%
29996	1	< 0.1%
29995	1	< 0.1%
29994	1	< 0.1%
29993	1	< 0.1%
29992	1	< 0.1%
29991	1	< 0.1%

LIMIT_BAL
Real number (ℝ)

Distinct	81
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	167484.32

Minimum	10000
Maximum	1000000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	234.5 KiB

Quantile statistics

Minimum	10000
5-th percentile	20000
Q1	50000
median	140000
Q3	240000
95-th percentile	430000
Maximum	1000000
Range	990000
Interquartile range (IQR)	190000

Descriptive statistics

Standard deviation	129747.66
Coefficient of variation (CV)	0.77468541
Kurtosis	0.5362629
Mean	167484.32
Median Absolute Deviation (MAD)	90000
Skewness	0.99286696
Sum	5.0245297 × 10⁹
Variance	1.6834456 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
50000	3365	11.2%
20000	1976	6.6%
30000	1610	5.4%
80000	1567	5.2%
200000	1528	5.1%
150000	1110	3.7%
100000	1048	3.5%
180000	995	3.3%
360000	881	2.9%
60000	825	2.8%
Other values (71)	15095	50.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10000	493	1.6%
16000	2	< 0.1%
20000	1976	6.6%
30000	1610	5.4%
40000	230	0.8%
50000	3365	11.2%
60000	825	2.8%
70000	731	2.4%
80000	1567	5.2%
90000	651	2.2%

Value	Count	Frequency (%)
1000000	1	< 0.1%
800000	2	< 0.1%
780000	2	< 0.1%
760000	1	< 0.1%
750000	4	< 0.1%
740000	2	< 0.1%
730000	2	< 0.1%
720000	3	< 0.1%
710000	6	< 0.1%
700000	8	< 0.1%

SEX
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	234.5 KiB

2	18112
1	11888

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	30000
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2
2nd row	2
3rd row	2
4th row	2
5th row	1

Common Values

Value	Count	Frequency (%)
2	18112	60.4%
1	11888	39.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2	18112	60.4%
1	11888	39.6%

Most occurring characters

Value	Count	Frequency (%)
2	18112	60.4%
1	11888	39.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	30000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
2	18112	60.4%
1	11888	39.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	30000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
2	18112	60.4%
1	11888	39.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	30000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
2	18112	60.4%
1	11888	39.6%

EDUCATION
Real number (ℝ)

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.8531333

Minimum	0
Maximum	6
Zeros	14
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	234.5 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	2
Q3	2
95-th percentile	3
Maximum	6
Range	6
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.79034866
Coefficient of variation (CV)	0.42649314
Kurtosis	2.0786216
Mean	1.8531333
Median Absolute Deviation (MAD)	1
Skewness	0.97097205
Sum	55594
Variance	0.624651
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
2	14030	46.8%
1	10585	35.3%
3	4917	16.4%
5	280	0.9%
4	123	0.4%
6	51	0.2%
0	14	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	14	< 0.1%
1	10585	35.3%
2	14030	46.8%
3	4917	16.4%
4	123	0.4%
5	280	0.9%
6	51	0.2%

Value	Count	Frequency (%)
6	51	0.2%
5	280	0.9%
4	123	0.4%
3	4917	16.4%
2	14030	46.8%
1	10585	35.3%
0	14	< 0.1%

MARRIAGE
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	234.5 KiB

2	15964
1	13659
3	323
0	54

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	30000
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	2
3rd row	2
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
2	15964	53.2%
1	13659	45.5%
3	323	1.1%
0	54	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2	15964	53.2%
1	13659	45.5%
3	323	1.1%
0	54	0.2%

Most occurring characters

Value	Count	Frequency (%)
2	15964	53.2%
1	13659	45.5%
3	323	1.1%
0	54	0.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	30000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
2	15964	53.2%
1	13659	45.5%
3	323	1.1%
0	54	0.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	30000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
2	15964	53.2%
1	13659	45.5%
3	323	1.1%
0	54	0.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	30000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
2	15964	53.2%
1	13659	45.5%
3	323	1.1%
0	54	0.2%

AGE
Real number (ℝ)

Distinct	56
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	35.4855

Minimum	21
Maximum	79
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	234.5 KiB

Quantile statistics

Minimum	21
5-th percentile	23
Q1	28
median	34
Q3	41
95-th percentile	53
Maximum	79
Range	58
Interquartile range (IQR)	13

Descriptive statistics

Standard deviation	9.2179041
Coefficient of variation (CV)	0.25976537
Kurtosis	0.044303378
Mean	35.4855
Median Absolute Deviation (MAD)	6
Skewness	0.73224587
Sum	1064565
Variance	84.969755
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
29	1605	5.3%
27	1477	4.9%
28	1409	4.7%
30	1395	4.7%
26	1256	4.2%
31	1217	4.1%
25	1186	4.0%
34	1162	3.9%
32	1158	3.9%
33	1146	3.8%
Other values (46)	16989	56.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
21	67	0.2%
22	560	1.9%
23	931	3.1%
24	1127	3.8%
25	1186	4.0%
26	1256	4.2%
27	1477	4.9%
28	1409	4.7%
29	1605	5.3%
30	1395	4.7%

Value	Count	Frequency (%)
79	1	< 0.1%
75	3	< 0.1%
74	1	< 0.1%
73	4	< 0.1%
72	3	< 0.1%
71	3	< 0.1%
70	10	< 0.1%
69	15	0.1%
68	5	< 0.1%
67	16	0.1%

PAY_0
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-0.0167

Minimum	-2
Maximum	8
Zeros	14737
Zeros (%)	49.1%
Negative	8445
Negative (%)	28.1%
Memory size	234.5 KiB

Quantile statistics

Minimum	-2
5-th percentile	-2
Q1	-1
median	0
Q3	0
95-th percentile	2
Maximum	8
Range	10
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.1238015
Coefficient of variation (CV)	-67.293505
Kurtosis	2.720715
Mean	-0.0167
Median Absolute Deviation (MAD)	1
Skewness	0.73197493
Sum	-501
Variance	1.2629299
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
0	14737	49.1%
-1	5686	19.0%
1	3688	12.3%
-2	2759	9.2%
2	2667	8.9%
3	322	1.1%
4	76	0.3%
5	26	0.1%
8	19	0.1%
6	11	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-2	2759	9.2%
-1	5686	19.0%
0	14737	49.1%
1	3688	12.3%
2	2667	8.9%
3	322	1.1%
4	76	0.3%
5	26	0.1%
6	11	< 0.1%
7	9	< 0.1%

Value	Count	Frequency (%)
8	19	0.1%
7	9	< 0.1%
6	11	< 0.1%
5	26	0.1%
4	76	0.3%
3	322	1.1%
2	2667	8.9%
1	3688	12.3%
0	14737	49.1%
-1	5686	19.0%

PAY_2
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-0.13376667

Minimum	-2
Maximum	8
Zeros	15730
Zeros (%)	52.4%
Negative	9832
Negative (%)	32.8%
Memory size	234.5 KiB

Quantile statistics

Minimum	-2
5-th percentile	-2
Q1	-1
median	0
Q3	0
95-th percentile	2
Maximum	8
Range	10
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.197186
Coefficient of variation (CV)	-8.9498079
Kurtosis	1.5704177
Mean	-0.13376667
Median Absolute Deviation (MAD)	0
Skewness	0.79056502
Sum	-4013
Variance	1.4332543
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
0	15730	52.4%
-1	6050	20.2%
2	3927	13.1%
-2	3782	12.6%
3	326	1.1%
4	99	0.3%
1	28	0.1%
5	25	0.1%
7	20	0.1%
6	12	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-2	3782	12.6%
-1	6050	20.2%
0	15730	52.4%
1	28	0.1%
2	3927	13.1%
3	326	1.1%
4	99	0.3%
5	25	0.1%
6	12	< 0.1%
7	20	0.1%

Value	Count	Frequency (%)
8	1	< 0.1%
7	20	0.1%
6	12	< 0.1%
5	25	0.1%
4	99	0.3%
3	326	1.1%
2	3927	13.1%
1	28	0.1%
0	15730	52.4%
-1	6050	20.2%

PAY_3
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-0.1662

Minimum	-2
Maximum	8
Zeros	15764
Zeros (%)	52.5%
Negative	10023
Negative (%)	33.4%
Memory size	234.5 KiB

Quantile statistics

Minimum	-2
5-th percentile	-2
Q1	-1
median	0
Q3	0
95-th percentile	2
Maximum	8
Range	10
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.1968676
Coefficient of variation (CV)	-7.2013692
Kurtosis	2.0844359
Mean	-0.1662
Median Absolute Deviation (MAD)	0
Skewness	0.84068183
Sum	-4986
Variance	1.432492
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
0	15764	52.5%
-1	5938	19.8%
-2	4085	13.6%
2	3819	12.7%
3	240	0.8%
4	76	0.3%
7	27	0.1%
6	23	0.1%
5	21	0.1%
1	4	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-2	4085	13.6%
-1	5938	19.8%
0	15764	52.5%
1	4	< 0.1%
2	3819	12.7%
3	240	0.8%
4	76	0.3%
5	21	0.1%
6	23	0.1%
7	27	0.1%

Value	Count	Frequency (%)
8	3	< 0.1%
7	27	0.1%
6	23	0.1%
5	21	0.1%
4	76	0.3%
3	240	0.8%
2	3819	12.7%
1	4	< 0.1%
0	15764	52.5%
-1	5938	19.8%

PAY_4
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-0.22066667

Minimum	-2
Maximum	8
Zeros	16455
Zeros (%)	54.9%
Negative	10035
Negative (%)	33.5%
Memory size	234.5 KiB

Quantile statistics

Minimum	-2
5-th percentile	-2
Q1	-1
median	0
Q3	0
95-th percentile	2
Maximum	8
Range	10
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.1691386
Coefficient of variation (CV)	-5.2982113
Kurtosis	3.4969835
Mean	-0.22066667
Median Absolute Deviation (MAD)	0
Skewness	0.99962941
Sum	-6620
Variance	1.3668851
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
0	16455	54.9%
-1	5687	19.0%
-2	4348	14.5%
2	3159	10.5%
3	180	0.6%
4	69	0.2%
7	58	0.2%
5	35	0.1%
6	5	< 0.1%
1	2	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-2	4348	14.5%
-1	5687	19.0%
0	16455	54.9%
1	2	< 0.1%
2	3159	10.5%
3	180	0.6%
4	69	0.2%
5	35	0.1%
6	5	< 0.1%
7	58	0.2%

Value	Count	Frequency (%)
8	2	< 0.1%
7	58	0.2%
6	5	< 0.1%
5	35	0.1%
4	69	0.2%
3	180	0.6%
2	3159	10.5%
1	2	< 0.1%
0	16455	54.9%
-1	5687	19.0%

PAY_5
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-0.2662

Minimum	-2
Maximum	8
Zeros	16947
Zeros (%)	56.5%
Negative	10085
Negative (%)	33.6%
Memory size	234.5 KiB

Quantile statistics

Minimum	-2
5-th percentile	-2
Q1	-1
median	0
Q3	0
95-th percentile	2
Maximum	8
Range	10
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.1331874
Coefficient of variation (CV)	-4.2569024
Kurtosis	3.9897481
Mean	-0.2662
Median Absolute Deviation (MAD)	0
Skewness	1.008197
Sum	-7986
Variance	1.2841137
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	16947	56.5%
-1	5539	18.5%
-2	4546	15.2%
2	2626	8.8%
3	178	0.6%
4	84	0.3%
7	58	0.2%
5	17	0.1%
6	4	< 0.1%
8	1	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-2	4546	15.2%
-1	5539	18.5%
0	16947	56.5%
2	2626	8.8%
3	178	0.6%
4	84	0.3%
5	17	0.1%
6	4	< 0.1%
7	58	0.2%
8	1	< 0.1%

Value	Count	Frequency (%)
8	1	< 0.1%
7	58	0.2%
6	4	< 0.1%
5	17	0.1%
4	84	0.3%
3	178	0.6%
2	2626	8.8%
0	16947	56.5%
-1	5539	18.5%
-2	4546	15.2%

PAY_6
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-0.2911

Minimum	-2
Maximum	8
Zeros	16286
Zeros (%)	54.3%
Negative	10635
Negative (%)	35.4%
Memory size	234.5 KiB

Quantile statistics

Minimum	-2
5-th percentile	-2
Q1	-1
median	0
Q3	0
95-th percentile	2
Maximum	8
Range	10
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.1499876
Coefficient of variation (CV)	-3.95049
Kurtosis	3.4265341
Mean	-0.2911
Median Absolute Deviation (MAD)	0
Skewness	0.94802939
Sum	-8733
Variance	1.3224715
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	16286	54.3%
-1	5740	19.1%
-2	4895	16.3%
2	2766	9.2%
3	184	0.6%
4	49	0.2%
7	46	0.2%
6	19	0.1%
5	13	< 0.1%
8	2	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-2	4895	16.3%
-1	5740	19.1%
0	16286	54.3%
2	2766	9.2%
3	184	0.6%
4	49	0.2%
5	13	< 0.1%
6	19	0.1%
7	46	0.2%
8	2	< 0.1%

Value	Count	Frequency (%)
8	2	< 0.1%
7	46	0.2%
6	19	0.1%
5	13	< 0.1%
4	49	0.2%
3	184	0.6%
2	2766	9.2%
0	16286	54.3%
-1	5740	19.1%
-2	4895	16.3%

default.payment.next.month
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	234.5 KiB

0	23364
1	6636

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	30000
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	23364	77.9%
1	6636	22.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	23364	77.9%
1	6636	22.1%

Most occurring characters

Value	Count	Frequency (%)
0	23364	77.9%
1	6636	22.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	30000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	23364	77.9%
1	6636	22.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	30000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	23364	77.9%
1	6636	22.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	30000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	23364	77.9%
1	6636	22.1%

overdue pay_mon1
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	23767
Distinct (%)	79.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	45559.75

Minimum	-733744
Maximum	913727
Zeros	2139
Zeros (%)	7.1%
Negative	4330
Negative (%)	14.4%
Memory size	234.5 KiB

Quantile statistics

Minimum	-733744
5-th percentile	-5095.95
Q1	745
median	18550.5
Q3	62241.5
95-th percentile	191911.6
Maximum	913727
Range	1647471
Interquartile range (IQR)	61496.5

Descriptive statistics

Standard deviation	73173.789
Coefficient of variation (CV)	1.606106
Kurtosis	9.7909586
Mean	45559.75
Median Absolute Deviation (MAD)	18914.5
Skewness	2.3003331
Sum	1.3667925 × 10⁹
Variance	5.3544035 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2139	7.1%
780	62	0.2%
2500	61	0.2%
2400	38	0.1%
390	33	0.1%
-390	30	0.1%
-200	30	0.1%
1050	21	0.1%
-780	21	0.1%
-1	20	0.1%
Other values (23757)	27545	91.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-733744	1	< 0.1%
-670580	1	< 0.1%
-422237	1	< 0.1%
-398516	1	< 0.1%
-380039	1	< 0.1%
-298887	1	< 0.1%
-296278	1	< 0.1%
-273955	1	< 0.1%
-262123	1	< 0.1%
-260148	1	< 0.1%

Value	Count	Frequency (%)
913727	1	< 0.1%
726314	1	< 0.1%
624562	1	< 0.1%
605989	1	< 0.1%
602458	1	< 0.1%
599725	1	< 0.1%
590523	1	< 0.1%
586654	1	< 0.1%
585018	1	< 0.1%
581775	1	< 0.1%

overdue pay_mon2
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	23422
Distinct (%)	78.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	43257.912

Minimum	-1702347
Maximum	933208
Zeros	2503
Zeros (%)	8.3%
Negative	4529
Negative (%)	15.1%
Memory size	234.5 KiB

Quantile statistics

Minimum	-1702347
5-th percentile	-5694.3
Q1	329.5
median	18102.5
Q3	59077.75
95-th percentile	185663.85
Maximum	933208
Range	2635555
Interquartile range (IQR)	58748.25

Descriptive statistics

Standard deviation	72565.937
Coefficient of variation (CV)	1.6775183
Kurtosis	23.537988
Mean	43257.912
Median Absolute Deviation (MAD)	18432.5
Skewness	1.4478358
Sum	1.2977374 × 10⁹
Variance	5.2658152 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2503	8.3%
780	64	0.2%
-390	55	0.2%
2500	50	0.2%
2400	40	0.1%
390	31	0.1%
-780	31	0.1%
150	27	0.1%
-1	27	0.1%
-200	25	0.1%
Other values (23412)	27147	90.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-1702347	1	< 0.1%
-1038728	1	< 0.1%
-1024731	1	< 0.1%
-745700	1	< 0.1%
-412824	1	< 0.1%
-391348	1	< 0.1%
-384520	1	< 0.1%
-376258	1	< 0.1%
-360785	1	< 0.1%
-357729	1	< 0.1%

Value	Count	Frequency (%)
933208	1	< 0.1%
723629	1	< 0.1%
641063	1	< 0.1%
602100	1	< 0.1%
591943	1	< 0.1%
585655	1	< 0.1%
581775	1	< 0.1%
575895	1	< 0.1%
572677	1	< 0.1%
566404	1	< 0.1%

overdue pay_mon3
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	23001
Distinct (%)	76.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	41787.473

Minimum	-854641
Maximum	1542258
Zeros	2890
Zeros (%)	9.6%
Negative	4265
Negative (%)	14.2%
Memory size	234.5 KiB

Quantile statistics

Minimum	-854641
5-th percentile	-5466.5
Q1	262.75
median	17769
Q3	56294.25
95-th percentile	179756
Maximum	1542258
Range	2396899
Interquartile range (IQR)	56031.5

Descriptive statistics

Standard deviation	69295.361
Coefficient of variation (CV)	1.6582807
Kurtosis	17.366827
Mean	41787.473
Median Absolute Deviation (MAD)	17772
Skewness	2.5328619
Sum	1.2536242 × 10⁹
Variance	4.801847 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2890	9.6%
780	64	0.2%
2400	41	0.1%
2500	39	0.1%
-390	36	0.1%
390	30	0.1%
-150	27	0.1%
-780	27	0.1%
-1	24	0.1%
150	24	0.1%
Other values (22991)	26798	89.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-854641	1	< 0.1%
-490073	1	< 0.1%
-386187	1	< 0.1%
-370996	1	< 0.1%
-365918	1	< 0.1%
-361020	1	< 0.1%
-358927	1	< 0.1%
-340547	1	< 0.1%
-337516	1	< 0.1%
-337200	1	< 0.1%

Value	Count	Frequency (%)
1542258	1	< 0.1%
854454	1	< 0.1%
663643	1	< 0.1%
659627	1	< 0.1%
614820	1	< 0.1%
576564	1	< 0.1%
572677	1	< 0.1%
568447	1	< 0.1%
562798	1	< 0.1%
555715	1	< 0.1%

overdue pay_mon4
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	22682
Distinct (%)	75.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	38436.872

Minimum	-667000
Maximum	841586
Zeros	3118
Zeros (%)	10.4%
Negative	4096
Negative (%)	13.7%
Memory size	234.5 KiB

Quantile statistics

Minimum	-667000
5-th percentile	-4440
Q1	230
median	16970
Q3	50259.5
95-th percentile	166742.1
Maximum	841586
Range	1508586
Interquartile range (IQR)	50029.5

Descriptive statistics

Standard deviation	64200.611
Coefficient of variation (CV)	1.6702871
Kurtosis	10.872025
Mean	38436.872
Median Absolute Deviation (MAD)	16970
Skewness	2.3643581
Sum	1.1531062 × 10⁹
Variance	4.1217184 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3118	10.4%
780	89	0.3%
-150	49	0.2%
2400	40	0.1%
390	31	0.1%
2500	30	0.1%
-390	30	0.1%
-1	24	0.1%
-18	24	0.1%
1050	23	0.1%
Other values (22672)	26542	88.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-667000	1	< 0.1%
-502024	1	< 0.1%
-415069	1	< 0.1%
-413122	1	< 0.1%
-330982	1	< 0.1%
-316943	1	< 0.1%
-299159	1	< 0.1%
-294999	1	< 0.1%
-281225	1	< 0.1%
-274421	1	< 0.1%

Value	Count	Frequency (%)
841586	1	< 0.1%
691864	1	< 0.1%
572805	1	< 0.1%
556792	1	< 0.1%
551811	1	< 0.1%
549435	1	< 0.1%
545669	1	< 0.1%
534020	1	< 0.1%
526372	1	< 0.1%
523016	1	< 0.1%

overdue pay_mon5
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	22058
Distinct (%)	73.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	35512.013

Minimum	-414380
Maximum	877171
Zeros	3364
Zeros (%)	11.2%
Negative	4356
Negative (%)	14.5%
Memory size	234.5 KiB

Quantile statistics

Minimum	-414380
5-th percentile	-4531.05
Q1	0
median	15538
Q3	46961.5
95-th percentile	157664.75
Maximum	877171
Range	1291551
Interquartile range (IQR)	46961.5

Descriptive statistics

Standard deviation	60553.37
Coefficient of variation (CV)	1.7051517
Kurtosis	11.574377
Mean	35512.013
Median Absolute Deviation (MAD)	15538
Skewness	2.4636987
Sum	1.0653604 × 10⁹
Variance	3.6667106 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3364	11.2%
780	83	0.3%
-150	74	0.2%
150	46	0.2%
390	42	0.1%
2400	37	0.1%
2500	32	0.1%
-780	31	0.1%
-18	31	0.1%
-1	27	0.1%
Other values (22048)	26233	87.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-414380	1	< 0.1%
-413122	1	< 0.1%
-375537	1	< 0.1%
-330982	1	< 0.1%
-312435	1	< 0.1%
-306663	1	< 0.1%
-302699	1	< 0.1%
-301088	1	< 0.1%
-296730	1	< 0.1%
-290275	1	< 0.1%

Value	Count	Frequency (%)
877171	1	< 0.1%
805167	1	< 0.1%
551863	1	< 0.1%
535865	1	< 0.1%
526372	1	< 0.1%
525702	1	< 0.1%
506815	1	< 0.1%
501474	1	< 0.1%
498139	1	< 0.1%
494143	1	< 0.1%

overdue pay_mon6
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	21718
Distinct (%)	72.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	33656.258

Minimum	-684896
Maximum	911408
Zeros	3854
Zeros (%)	12.8%
Negative	4527
Negative (%)	15.1%
Memory size	234.5 KiB

Quantile statistics

Minimum	-684896
5-th percentile	-5459.1
Q1	0
median	13926.5
Q3	46067.25
95-th percentile	153520.35
Maximum	911408
Range	1596304
Interquartile range (IQR)	46067.25

Descriptive statistics

Standard deviation	60151.291
Coefficient of variation (CV)	1.7872246
Kurtosis	11.924636
Mean	33656.258
Median Absolute Deviation (MAD)	13926.5
Skewness	2.1582519
Sum	1.0096877 × 10⁹
Variance	3.6181778 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3854	12.8%
150	74	0.2%
780	73	0.2%
-150	52	0.2%
-780	39	0.1%
-18	33	0.1%
2400	32	0.1%
-200	30	0.1%
390	29	0.1%
2500	29	0.1%
Other values (21708)	25755	85.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-684896	1	< 0.1%
-528466	1	< 0.1%
-513745	1	< 0.1%
-470934	1	< 0.1%
-396700	1	< 0.1%
-355318	1	< 0.1%
-329482	1	< 0.1%
-313110	1	< 0.1%
-301353	1	< 0.1%
-290091	1	< 0.1%

Value	Count	Frequency (%)
911408	1	< 0.1%
679638	1	< 0.1%
548638	1	< 0.1%
527496	1	< 0.1%
509566	1	< 0.1%
499975	1	< 0.1%
494918	1	< 0.1%
484100	1	< 0.1%
483211	1	< 0.1%
481792	1	< 0.1%

Auto

Heatmap
Table

	AGE	EDUCATION	ID	LIMIT_BAL	MARRIAGE	PAY_0	PAY_2	PAY_3	PAY_4	PAY_5	PAY_6	SEX	default.payment.next.month	overdue pay_mon1	overdue pay_mon2	overdue pay_mon3	overdue pay_mon4	overdue pay_mon5	overdue pay_mon6
AGE	1.000	0.159	0.025	0.186	0.286	-0.064	-0.083	-0.083	-0.080	-0.083	-0.076	0.091	0.048	-0.008	-0.008	-0.006	-0.013	-0.011	-0.011
EDUCATION	0.159	1.000	0.033	-0.264	0.114	0.132	0.169	0.162	0.152	0.137	0.124	0.029	0.072	0.110	0.109	0.098	0.085	0.081	0.079
ID	0.025	0.033	1.000	0.031	0.021	-0.025	-0.005	-0.009	-0.004	-0.016	-0.006	0.179	0.038	0.009	0.003	-0.002	0.031	0.013	0.014
LIMIT_BAL	0.186	-0.264	0.031	1.000	0.064	-0.296	-0.343	-0.332	-0.309	-0.285	-0.264	0.073	0.157	0.002	-0.008	0.002	0.018	0.017	0.011
MARRIAGE	0.286	0.114	0.021	0.064	1.000	0.023	0.037	0.042	0.045	0.047	0.044	0.032	0.033	0.007	0.010	0.005	0.011	0.009	0.011
PAY_0	-0.064	0.132	-0.025	-0.296	0.023	1.000	0.627	0.548	0.516	0.486	0.464	0.059	0.422	0.377	0.384	0.365	0.351	0.346	0.340
PAY_2	-0.083	0.169	-0.005	-0.343	0.037	0.627	1.000	0.799	0.713	0.674	0.635	0.071	0.340	0.593	0.566	0.533	0.511	0.495	0.479
PAY_3	-0.083	0.162	-0.009	-0.332	0.042	0.548	0.799	1.000	0.801	0.718	0.671	0.067	0.294	0.511	0.606	0.564	0.540	0.516	0.498
PAY_4	-0.080	0.152	-0.004	-0.309	0.045	0.516	0.713	0.801	1.000	0.822	0.732	0.063	0.278	0.504	0.535	0.632	0.593	0.560	0.533
PAY_5	-0.083	0.137	-0.016	-0.285	0.047	0.486	0.674	0.718	0.822	1.000	0.821	0.056	0.269	0.490	0.519	0.559	0.658	0.609	0.571
PAY_6	-0.076	0.124	-0.006	-0.264	0.044	0.464	0.635	0.671	0.732	0.821	1.000	0.047	0.249	0.481	0.510	0.541	0.579	0.668	0.615
SEX	0.091	0.029	0.179	0.073	0.032	0.059	0.071	0.067	0.063	0.056	0.047	1.000	0.039	-0.040	-0.042	-0.033	-0.026	-0.017	-0.019
default.payment.next.month	0.048	0.072	0.038	0.157	0.033	0.422	0.340	0.294	0.278	0.269	0.249	0.039	1.000	0.011	0.021	0.022	0.021	0.024	0.032
overdue pay_mon1	-0.008	0.110	0.009	0.002	0.007	0.377	0.593	0.511	0.504	0.490	0.481	-0.040	0.011	1.000	0.814	0.783	0.736	0.707	0.674
overdue pay_mon2	-0.008	0.109	0.003	-0.008	0.010	0.384	0.566	0.606	0.535	0.519	0.510	-0.042	0.021	0.814	1.000	0.799	0.767	0.729	0.698
overdue pay_mon3	-0.006	0.098	-0.002	0.002	0.005	0.365	0.533	0.564	0.632	0.559	0.541	-0.033	0.022	0.783	0.799	1.000	0.791	0.761	0.721
overdue pay_mon4	-0.013	0.085	0.031	0.018	0.011	0.351	0.511	0.540	0.593	0.658	0.579	-0.026	0.021	0.736	0.767	0.791	1.000	0.786	0.757
overdue pay_mon5	-0.011	0.081	0.013	0.017	0.009	0.346	0.495	0.516	0.560	0.609	0.668	-0.017	0.024	0.707	0.729	0.761	0.786	1.000	0.772
overdue pay_mon6	-0.011	0.079	0.014	0.011	0.011	0.340	0.479	0.498	0.533	0.571	0.615	-0.019	0.032	0.674	0.698	0.721	0.757	0.772	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	ID	LIMIT_BAL	SEX	EDUCATION	MARRIAGE	AGE	PAY_0	PAY_2	PAY_3	PAY_4	PAY_5	PAY_6	default.payment.next.month	overdue pay_mon1	overdue pay_mon2	overdue pay_mon3	overdue pay_mon4	overdue pay_mon5	overdue pay_mon6
0	1	20000.0	2	2	1	24	2	2	-1	-1	-2	-2	1	3913.0	2413.0	689.0	0.0	0.0	0.0
1	2	120000.0	2	2	2	26	-1	2	0	0	0	2	1	2682.0	725.0	1682.0	2272.0	3455.0	1261.0
2	3	90000.0	2	2	2	34	0	0	0	0	0	0	0	27721.0	12527.0	12559.0	13331.0	13948.0	10549.0
3	4	50000.0	2	2	1	37	0	0	0	0	0	0	0	44990.0	46214.0	48091.0	27214.0	27890.0	28547.0
4	5	50000.0	1	2	1	57	-1	0	-1	0	0	0	0	6617.0	-31011.0	25835.0	11940.0	18457.0	18452.0
5	6	50000.0	1	1	2	37	0	0	0	0	0	0	0	61900.0	55254.0	56951.0	18394.0	18619.0	19224.0
6	7	500000.0	1	1	2	29	0	0	0	0	0	0	0	312965.0	372023.0	407007.0	522414.0	469253.0	460174.0
7	8	100000.0	2	2	2	23	0	-1	-1	0	0	-1	0	11496.0	-221.0	601.0	-360.0	-1846.0	-975.0
8	9	140000.0	2	3	1	28	0	0	2	0	0	0	0	7956.0	14096.0	11676.0	11211.0	10793.0	2719.0
9	10	20000.0	1	3	2	35	-2	-2	-2	-2	-1	-1	0	0.0	0.0	0.0	-13007.0	11885.0	13912.0

	ID	LIMIT_BAL	SEX	EDUCATION	MARRIAGE	AGE	PAY_0	PAY_2	PAY_3	PAY_4	PAY_5	PAY_6	default.payment.next.month	overdue pay_mon1	overdue pay_mon2	overdue pay_mon3	overdue pay_mon4	overdue pay_mon5	overdue pay_mon6
29990	29991	140000.0	1	2	1	41	0	0	0	0	0	0	0	132325.0	130142.0	134882.0	136757.0	47675.0	44121.0
29991	29992	210000.0	1	2	1	34	3	2	2	2	2	2	1	2500.0	2500.0	2500.0	2500.0	2500.0	2500.0
29992	29993	10000.0	1	3	1	43	0	0	0	-2	-2	-2	0	6802.0	10400.0	0.0	0.0	0.0	0.0
29993	29994	100000.0	1	1	2	38	0	-1	-1	0	0	0	0	1042.0	-110357.0	98996.0	67626.0	67473.0	53004.0
29994	29995	80000.0	1	2	2	34	2	2	2	2	2	2	1	65557.0	74208.0	79384.0	70519.0	82607.0	77158.0
29995	29996	220000.0	1	3	1	39	0	0	0	0	0	0	0	180448.0	172815.0	203362.0	84957.0	26237.0	14980.0
29996	29997	150000.0	1	3	2	43	-1	-1	-1	-1	0	0	0	-154.0	-1698.0	-5496.0	8850.0	5190.0	0.0
29997	29998	30000.0	1	2	2	37	4	3	2	-1	0	0	1	3565.0	3356.0	-19242.0	16678.0	18582.0	16257.0
29998	29999	80000.0	1	3	1	41	1	-1	0	0	0	-1	1	-87545.0	74970.0	75126.0	50848.0	-41109.0	47140.0
29999	30000	50000.0	1	2	1	46	0	0	0	0	0	0	1	45851.0	47105.0	48334.0	35535.0	31428.0	14313.0

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample